package it.nola.soccer;

public class DbConst {
    public static final class actions {
	public static final String KEY_ROWID="_id";
	public static final String KEY_CRONACA="cronaca";
	public static final String KEY_TEAM="team";
	public static final String KEY_MIN="min";
	public static final String KEY_HALF="time";
	public static final String KEY_DESCRI="descri";
	public static final String NAME="actions";
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_DESCRI, KEY_CRONACA, KEY_TEAM, KEY_MIN,
	    KEY_HALF };
    }

    public static final class cards {
	public static final String KEY_ROWID="_id";
	public static final String KEY_PLAYER="player";
	public static final String KEY_CRONACA="cronaca";
	public static final String KEY_TEAM="team";
	public static final String KEY_MIN="min";
	public static final String KEY_CARD="card";
	public static final String KEY_HALF="time";
	public static final String KEY_REASON="reason";
	public static final String KEY_NAME_PLAYER="name_player_card";
	public static final String NAME="cards";
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_PLAYER, KEY_CRONACA, KEY_TEAM, KEY_MIN,
	    KEY_HALF, KEY_REASON, KEY_CARD };
    }

    public static final class cronache {
	public static final String KEY_TITLE="title";
	public static final String KEY_BODY="notes";
	public static final String KEY_TEAM1="team1";
	public static final String KEY_TEAM2="team2";
	public static final String KEY_REFEREE="referee";
	public static final String KEY_RESULT="result";
	public static final String KEY_ASSISTENT1="assistent1";
	public static final String KEY_ASSISTENT2="assistent2";
	public static final String KEY_MATCH_DATE="dm";
	public static final String KEY_ROWID="_id";
	public static final String KEY_PLACE="place";
	public static final String NAME="cronache";
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_TITLE, KEY_BODY, KEY_TEAM1, KEY_TEAM2,
	    KEY_REFEREE, KEY_ASSISTENT1, KEY_ASSISTENT2, KEY_MATCH_DATE, KEY_PLACE, KEY_RESULT };
    }

    public static final class goals {
	public static final String KEY_ROWID="_id";
	public static final String KEY_PLAYER="player";
	public static final String KEY_CRONACA="cronaca";
	public static final String KEY_TEAM="team";
	public static final String KEY_MIN="min";
	public static final String KEY_HALF="time";
	public static final String KEY_IS_AUTO="is_auto";
	public static final String KEY_NAME_PLAYER="name_player_goal";
	public static final String NAME="goals";
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_PLAYER, KEY_CRONACA, KEY_TEAM, KEY_MIN,
	    KEY_HALF, KEY_IS_AUTO };
    }

    public static final class players {
	public static final String KEY_ROWID="_id";
	public static final String KEY_CRONACA="cronaca";
	public static final String KEY_NR="nr";
	public static final String KEY_TEAM="team";
	public static final String KEY_NAME="name";
	public static final String NAME="players";
	public static final int MAX_NUMBER=19;
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_NR, KEY_CRONACA, KEY_TEAM, KEY_NAME };
    }

    public static final class subst {
	public static final String KEY_ROWID="_id";
	public static final String KEY_PLAYER_IN="player_in";
	public static final String KEY_PLAYER_OUT="player_out";
	public static final String KEY_CRONACA="cronaca";
	public static final String KEY_TEAM="team";
	public static final String KEY_MIN="min";
	public static final String KEY_HALF="time";
	public static final String[] ALL_FIELDS=new String[]{KEY_ROWID, KEY_PLAYER_IN, KEY_CRONACA, KEY_TEAM, KEY_MIN,
	    KEY_HALF, KEY_PLAYER_OUT };
	public static final String NAME="subst";
	public static final String KEY_NAME_PLAYER_IN="name_player_in";
	public static final String KEY_NAME_PLAYER_OUT="name_player_out";
	public static final String KEY_TEAM_SUBST="team_subst";
    }

    public static final String DATABASE_NAME="soccer_notes";
    public static final short[] HALFS=new short[]{1, 2, 3, 4 };
    public static final Short HOME_TEAM=1;
    public static final Short FOREIGN_TEAM=2;
    public static final short[] TEAMS=new short[]{HOME_TEAM, FOREIGN_TEAM };
    public static final Short YELLOW_CARD=1;
    public static final Short RED_CARD=2;
    public static final short[] CARDS=new short[]{YELLOW_CARD, RED_CARD };

}
